Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);
3 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
4 ?>
5 <?php
6 require_once('session1.php');
7 ?>
8
9
10 <!DOCTYPE html>
11 <html>
12
13 <head>
14 <meta charset="utf-8">
15 <meta name="viewport" content="width=device-width, initial-scale=1.0">
16 <title>school management system</title>
17 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
18 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
19 <link href="assets/css/loader.css" rel="stylesheet" />
20 <script src="assets/js/canvasjs.min.js"></script>
21 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
22 <script src="assets/js/jquery-3.2.1.js"></script>
23
24
25 </head>
26
27 <body >
28 <div style="
29 font-family:Nyala, Arial;
30 text-align: left;
31 background-color: #526F35;
32 padding: 20px;
33 color:white;
34 width: 100%;
35 height: 150px;">
36 <h2><img src="assets/img/logo.png">School Management System
37 <div style="float:right; font-size:20px;text-align:right;">
38 <img src="assets/img/mail2.png">Email: info@jmax.ac.ke<br>
39 <img src="assets/img/call1.png">Contact:+254729734768<br>
40 <img src="assets/img/location.png">Location: gituamba plaza, Ruiru town
41 </div>
42 </h2>
43 </div>
44 <?php
45 //echo "i love you".$selectedcounty;
46 ?>
47
48 <div style="float:left;"></div></div><div style="float:right;">Current User: <font color="orange">John</font> <a href="xxx">Log Out<img src="assets/img/logout.png"></a></div><hr>
49
50 <div>
51 <ul class="nav nav-tabs">
52 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
53 <li class="active"><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
54 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
55 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
56 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
57 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
58 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
59 <li><a href="parents.php">Parents/Guardians <img src="assets/img/details.png"></a></li>
60 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
61 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
62
63 </ul>
64 <div class="tab-content">
65 <div class="tab-pane active" role="tabpanel" id="tab-1">
66
67 <p>
68 <div class="table-responsive" >
69 <!--**************************************************************************************************************************-->
70 <div class="container" style="width:100%">
71
72 <ul class="nav nav-tabs">
73 <li ><a href="students.php">New Student <img src="assets/img/new.png"> </a></li>
74 <li class="active"> <a href="viewstudentsedit1.php">Update Existing Record <img src="assets/img/update2.png"> </a></li>
75 <li><a href="deletestudentrecord.php">Delete Record<img src="assets/img/delete2.png"></a></li>
76 <li><a href="viewstudentrecord.php">View List<img src="assets/img/view2.png"></a></li>
77 <li><a href="importstudentlist.php">Export Data (CSV) <img src="assets/img/import.png"></a></li>
78 <li><a href="exportstudentlist.php">Bulk Sms <img src="assets/img/export.png"></a></li>
79 <li><a href="searchstudent.php">Search <img src="assets/img/search.png"></a></li>
80 <li><a href="billingstudent.php">Billing </a></li>
81 <li><a href="studentcreditnotes.php">Credit Notes </a></li>
82 </ul>
83 <br>
84
85 </div>
86 <!--**************ths is the success msg on saving the cord-->
87 <div style="width:100%; color:red; background-color:orange;text-align:center">
88 <?php
89 //echo $msg;
90 ?>
91 </div>
92
93 <!--*************************************************************************************************************************-->
94 <div class="form-group">
95
96 <form action="viewstudentsedit1.php" method="POST" enctype="multipart/form-data">
97 <table class="table table-hover table-striped" style="border-top:3px solid red" >
98
99 <tr><td colspan="4" style="height:0.2px;"><h4>Personal Details (Admission Number<input type="text" name="student_id" value="<?php echo $id?>">)</h4></td></tr>
100 <tr>
101 <td colspan="4">
102 Sir name<input type="text" name="idno" placeholder="e.g Kimani" >
103 Firstname Name<input type="text" name="fname" >
104 Last Name<input type="text" name="lname" >
105 salary<input type="text" name="salary" ><br><br>
106
107 <tr><td>
108 <input type="submit" name="register" value="Update Record" class="btn btn-success">
109
110 </td>
111
112 </tr>
113 </table>
114 </form>
115
116 </div>
117
118
119 <?php //diri na mah submit ang data. lantawun nia kung mai onud ang every txtbox
120 if (isset($_POST['register']))
121 {
122 if (($_POST['idno'] == '')or($_POST['fname'] == '')or($_POST['lname'] == '')or($_POST['salary'] == ''))
123 {
124 echo mysqli_error();
125 }
126 else{ //dri namn is ang mga "name=tenant_id" nga ara sa mga input type.
127 $idno = $_POST['idno'];
128 $fname = $_POST['fname'];
129 $lname= $_POST['lname'];
130 $salary = $_POST['salary'];
131
132 mysqli_query($conn,"UPDATE `trial` SET `idno`='idno',`fname`='fname',`lname`='lname',`salary`='salary] WHERE idno=1");
133
134
135
136 }
137 }
138 ?>
139 </div>
140 </p>
141
142
143 </div>
144
145 </div>
146 </div>
147
148 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
149 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
150 </div>
151 <script src="assets/js/jquery.min.js"></script>
152 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
153 <script src="assets/js/affix.js"></script>
154 <script src="assets/js/alert.js"></script>
155 <script src="assets/js/alert1.js"></script>
156 <script src="assets/js/bootstrap.js"></script>
157 <script src="assets/js/bootstrap.min.js"></script>
158 <script src="assets/js/bootstrap-datepicker.js"></script>
159 <script src="assets/js/bootstrap-wysihtml5.js"></script>
160 <script src="assets/js/button.js"></script>
161 <script src="assets/js/carousel.js"></script>
162 <script src="assets/js/chosen.jquery.min.js"></script>
163 <script src="assets/js/ckeditor.js"></script>
164 <script src="assets/js/collapse.js"></script>
165 <script src="assets/js/color.js"></script>
166 <script src="assets/js/dropdown.js"></script>
167 <script src="assets/js/DT_bootstrap.js"></script>
168 <script src="assets/js/dynamic.js"></script>
169 <script src="assets/js/ie-emulation-modes-warning.js"></script>
170 <script src="assets/js/jquery.dataTables.js"></script>
171 <script src="assets/js/jquery.dataTables.min.js"></script>
172 <script src="assets/js/jquery.dialog.js"></script>
173 <script src="assets/js/jquery.hoverdir.js"></script>
174 <script src="assets/js/jquery.jgrowl.js"></script>
175 <script src="assets/js/jquery.knob.js"></script>
176 <script src="assets/js/jquery.uniform.min.js"></script>
177 <script src="assets/js/jquery-1.8.3.min.js"></script>
178 <script src="assets/js/jquery-1.9.1.js"></script>
179 <script src="assets/js/jquery-1.9.1.min.js"></script>
180 <script src="assets/js/jquery-1.10.2.js"></script>
181 <script src="assets/js/jquery-1.11.0.js"></script>
182 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
183 <script src="assets/js/jquery-ui-1.10.3.js"></script>
184 <script src="assets/js/modal.js"></script>
185 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
186 <script src="assets/js/myjquery.js"></script>
187 <script src="assets/js/myjquery1.js"></script>
188 <script src="assets/js/npm.js"></script>
189 <script src="assets/js/popover.js"></script>
190 <script src="assets/js/profile.js"></script>
191 <script src="assets/js/raphael-min.js"></script>
192 <script src="assets/js/sb-admin-2.js"></script>
193 <script src="assets/js/scripts.js"></script>
194 <script src="assets/js/scrollspy.js"></script>
195 <script src="assets/js/tab.js"></script>
196 <script src="assets/js/tooltip.js"></script>
197 <script src="assets/js/transition.js"></script>
198 <script src="assets/js/wysihtml5-0.3.0.js"></script>
199 <script language="javascript" type="text/javascript">
200 $(window).load(function()
201 {
202 $('#loading').hide();
203 });
204 </script>
205 </body>
206
207 </html>
